class RoleMapper:
    GET_ROLE = """SELECT `role_id` FROM `aoa_role_` WHERE role_name='{role}'"""
    
    ADD_ROLE = """INSERT INTO `aoa_role_`(`role_name`, `role_value`) VALUES ('{role}',0)"""

    ROLE_ID_LIST = """SELECT `role_id` FROM `aoa_role_`"""
    
    INSERT_ROLE_LIST = """INSERT INTO aoa_role_power_list("is_show","menu_id","role_id") VALUES (1,{menu_id},{role_id})"""